Billing Report

The Billing Report shows the breakdown of posted and/or unposted invoices. This report includes the WIP available, the billed amount, and the remaining WIP. The report also shows the realization percent, percent of the WIP billed, and the write up/down percent.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

• Security group profile > Functional rights > Reports > Shared Library > Shared Views
• Security group profile > Functional rights > Reports > Firm Library > Custom
• Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
• Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
• Security group profile > Functional rights > Reports > Firm Library > <report name>

Reports in Foundation that are Comparable

In Practice Management, the comparable report is Billing Report. In Practice Advantage, there are no comparable reports.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
Option	Setting	Description
Hide Comma	Yes/No	Includes or excludes commas in numbers.
Hide Penny	Yes/No	Includes or excludes pennies in amounts.
Include Deleted Clients	Yes/No	Includes or excludes deleted client information.

Default Filters
Field Name	Operator	Value
Transaction Date	Between	First Day Of Current Fiscal Year, Last Day Of Current Fiscal Year
Transaction Type	=	All
Invoice Status	=	Posted

 

Optional Filters
Available Fields
Accounting Period Date	Client Primary Service Type	Primary Partner
Billed w/Progress	Client Region	Progress Bills
Business Code	Client Sub ID	Real % w/Progress
Client – Principal	Client Type	Real % w/o Progress
Client Bill Manager	Financial Reporting Client Group	Sales Tax
Client Billing Group	Invoice Status	Transaction Date
Client Business Unit	Invoiced w/o Progress	Transaction Type
Client ID	Line of Business	WIP Available
Client ID.Sub ID	Manager	WIP on Hold
Client Name	Percent Billed	WIP Remaining
Client Office	Posted Date	Write Up/Down

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields
Business Code	Client ID.Sub ID	Client Type
Client – Principal	Client Name	Financial Reporting Client Group
Client Bill Manager	Client Office	Line of Business
Client Billing Group	Client Primary Service Type	Manager
Client Business Unit	Client Region	Primary Partner
Client ID	Client Sub ID	Sort Name

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Available Fields
Billed w/Progress	Percent Billed	WIP Available
Client ID	Progress Bills	WIP on Hold
Client ID.Sub ID	Real % w/Progress	WIP Remaining
Client Name	Real % w/o Progress	Write Up/Down
Invoice w/o Progress	Sales Tax

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field	Description
Client ID	The client ID and sub-ID (Client ID.Sub-ID).
Client Name	The client name.
WIP Available	The total WIP amount of unbilled with a transaction date before the start date of the report + the total of billed and unbilled WIP with a transaction date within the date range entered.
WIP On Hold	The total WIP on hold as of the beginning date of the report.
Progress Bills	The total progress bills created during the date range selected.
Billed w/Progress	The total of the billed WIP + progress bills – progress applied during the date range selected.
WIP Remaining	The total of the WIP available –progress bills during the date range selected.
Percent Billed	The progress bills divided by the WIP available during the date range selected.
Invoiced w/o Progress	The billed WIP + the write up/down during the date range selected.
Real % w/Progress	The (billed WIP + write up/down + progress bills) / (billed WIP + progress bills) = invoiced with progress. The invoiced with progress divided by (billed WIP + progress bills) equals the real % with progress.
Real % w/o Progress	The invoiced without progress divided by billed WIP.
Sales Tax	The total amount of sales tax billed during the date range.
Write Up/Down	The total amount of write up/down during the date range.

Billing Report Sample